
USE master
GO

EXEC sp_addlogin 'BlueHillASPUser', 'Password01', 'BlueHill'
EXEC sp_addlogin 'BlueHillWinUser', 'Password01', 'BlueHill'
GO

IF DB_ID('BlueHill') IS NOT NULL BEGIN
    DROP DATABASE BlueHill
END
GO


use master
GO
create database BlueHill
GO

RESTORE DATABASE BlueHill 
   FROM DISK = 'c:\Case\BlueHill.bak'
GO

use BlueHill
GO

EXEC sp_change_users_login 'Update_One', 'BlueHillASPUser', 'BlueHillASPUser'
EXEC sp_change_users_login 'Update_One', 'BlueHillWinUser', 'BlueHillWinUser'
GO

